SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspCustomerInfo_UPDATE
(
@customerInfoId int = null,
@accountId int = null,
@cityId int = null,
@paymentTypeId int = null,
@firstName nvarchar(128) = null,
@middleName nvarchar(128) = null,
@lastName nvarchar(128) = null,
@postIndex int = null,
@postAddress nvarchar(256) = null,
@phone nvarchar(40) = null,
@icq int = null,
@skype nvarchar(256) = null,
@email nvarchar(256) = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[CustomerInfo]
SET
  [AccountId] = @accountId,
  [CityId] = @cityId,
  [PaymentTypeId] = @paymentTypeId,
  [FirstName] = @firstName,
  [MiddleName] = @middleName,
  [LastName] = @lastName,
  [PostIndex] = @postIndex,
  [PostAddress] = @postAddress,
  [Phone] = @phone,
  [Icq] = @icq,
  [Skype] = @skype,
  [Email] = @email,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [CustomerInfoId] = @customerInfoId


GO
